const user_sql = {
    selectUser: 'select a.id, username, gender, phone, email, state, r.role_name,password from auother a  left join `role` r on a.role_id = r.id where a.role_id=2',
    selectOne: 'select a.id, username,  gender, phone, email, state, r.role_name,password from auother a left join `role` r on a.role_id = r.id where a.role_id=2 and a.id = ?',
    selectUsername: 'select a.id, username,  gender, phone, email, state, r.role_name,password from auother a left join `role` r on a.role_id = r.id where a.username = ?',
    selectUserRole:'SELECT r.id, role_name FROM article.`role` r;',
    insertOne: 'INSERT INTO article.auother (username, gender, phone, email, state, role_id, password)VALUES(?,?,?,?,?,?,?);',
    deleteOne: 'DELETE FROM article.auother WHERE id=?;',
    getLoginAccount: 'select auother.username from auother  left join `role` r on r.id = auother.role_id  where auother.username = ? and auother.password = ? and r.role_name = ?'
}
module.exports = user_sql